1. Open Visual Studio with the SQL Server Data Tools plugin installed.
2. Select File > New > Project.
3. In the New Project dialog, select Report Server Project, enter a project name, and then click OK.

1. In the Solution Explorer pane, right-click your new project and select Properties.
2. Set OverwriteDatasets to True.
3. Set OverwriteDataSources to True.
4. Set TargetServerURL to the Web Service URL from the Reporting Services Configuration Manager.

   If your Report Server is on a different computer, make sure you use the fully qualified domain name of the Report Server computer. For example:

   http://mypc.bentley.com/reportservice

5. Click OK.
   

1. In the Solution Explorer pane, under your project, right-click the Shared Data Sources folder and select Add New Data Source.

   The Shared Data Source Properties dialog opens.

2. On the General page, do the following:
   1. In the Name field, enter a name for the shared data source. For example, MyAssetWiseDataSource
   2. Set Type to eB Data Model.
   3. In the Connection string field, enter the connection information for the AssetWise community you want to access.

      If using AssetWise Internal authentication, enter:

      Server=AssetWiseApplicationServerName;
      Name=AssetWiseDataSourceName;
      Integrated Security=false

      If using Windows authentication, enter:

      Server=AssetWiseApplicationServerName;
      Name=AssetWiseDataSourceName;
      Integrated Security=true

      For Bentley IMS authentication:

      The connection information when using Bentley IMS authentication is normally the same as Windows authentication, which is to set Integrated Security to true. However, to set up the shared data source for Bentley IMS authentication, you first need to set Integrated Security to "false" (as if you would be using eB Internal authentication). Later you will set Integrated Security to "true". But for now, enter the following:

      Server=AssetWiseApplicationServerName;
      Name=AssetWiseDataSourceName;
      Integrated Security=false

      Alternatively, Personal Access Token (PAT) issued by the AssetWise Session Service can be used for Bentley IMS authentication, (see To Get a Personal Access Token (PAT) from AssetWise Session Service). In this case, the report will use the IMS account that owns the PAT to get the AssetWise data:

      Server=AssetWiseApplicationServerName;
      Name=AssetWiseDataSourceName;
      UseIms=true;
      Access Token=AssetWiseSessionServicePersonalAccessToken

3. On the Credentials page, do the following:
   • If using eB Internal authentication, select Use this user name and password and enter the user name and password of a user account in your AssetWise community.
   • If using Windows authentication, select Use Windows Authentication (integrated security).
   • For Bentley IMS authentication:

     Just like on the General page, Bentley IMS authentication normally uses integrated security, the same as Windows authentication. However to set up the shared data source for Bentley IMS authentication, on this page you first need to select Use this user name and password and enter the user name and password of a user account in your AssetWise community. Later you will switch the setting on this page to use integrated security.

4. Click OK.
   

1. In the Solution Explorer pane, under your project, right-click the Reports folder and select Add New Report.
2. When the Report Wizard opens, click Next.
3. On the Select the Data Source page, select Shared data source, select the shared data source you just created, then click Next.
4. On the Design the Query page, enter a query in the Query string field. For example:

   START WITH Document SELECT Id, Class.Name, Name, State, ApprovalStatus WHERE Id <> 0

   You can also click the Query Builder button to open the Query Designer dialog to build and test your query. After you build your query, click the Edit as Text button and then click the exclamation point ! button to test the query. When finished, click OK to add the query to the Query string field.

   When finished building your query, click Next.

5. On the Select the Report Type page, select Tabular and click Next.
6. On the Design the Table page, select all items in the Available fields list and click Details >, then click Finish.
7. On the Completing the Report page, enter a name for the report and click Finish.

Server=<AssetWiseApplicationServerName>;
Name=<AssetWiseDatasourceName>;
Integrated Security=true

If you are using eB Internal or Windows authentication, you are done.

If using Bentley IMS authentication, the Reporting Services Login dialog opens. Continue with the next step.

This step assumes that you have already:

• Specified this Bentley IMS profile (email address) as the admin account in SQL Server Reporting Services. This is accomplished in the RSReportServer.config file (see Modify the Report Server's RSReportServer.config File ). The Bentley IMS profile must be specified as the admin account in order for you to be granted permission to deploy.
• Received a Personal Access Token (PAT) from AssetWise Session Service for this Bentley IMS profile.